File formats supported by access
Files with the following formats can be imported to Access 7.0:
1) Microsoft FoxPro 2.0, 2.5, 2.6, and 3.0
2) dBASE III, III+, IV, and 5
3) Paradox 3.x, 4.x, and 5.0
4) SQL tables, and data from programs and databases that support the ODBC protocol, including but not limited to Microsoft SQL Server
5) Microsoft Excel 2.0, 3.0, 4.0, 5.0, and 7.0 spreadsheets
6) Lotus 1-2-3 spreadsheets .WKS, .WK1, and .WK3 formats
7) Delimited text files
NOTE: Delimited text files are mostly files with values separated by commas, tabs, or other characters. The files must also be in MS-DOS or Windows ANSI text format.
8) Fixed-width text files
NOTE: Fixed-width text files are mostly files with values arranged so that each field has a certain width. The files must also be in MS-DOS or Windows ANSI text format.